ETL Consultant with Reporting - ICONMA, LLC
Addison, TX 75001
About the Job
Location: Addison, TX/Plano, TX/Charlotte, NC/Pennington, NJ /Hybrid
Duration: 4 Months
Description:
Top Must Have:
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
Duration: 4 Months
Description:
- This role is responsible for leading the transformation of the enterprise ETL platforms which requires engagement across multiple line of business.
- Key responsibilities include setting up automations, coordinating delivery, providing visibility of program health, and managing program risks.
- This role facilitates sync points between business and technology leaders across, as well as Risk and Compliance partners.
- Individuals in the role also ensure delivery meets the client’s expectations in terms of the target outcomes, timeline and cost.
- Develop and deliver data ETL solutions to accomplish technology and business goals.
- Code solutions to ingest, curate, aggregate, integrate, clean, transform, and control data in operational and/or analytics data systems per the defined acceptance criteria.
- Assemble large, complex data sets to meet functional reporting requirements.
- Build processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management.
- Define and build reporting applications that enable better data-informed decision-making.
- Contribute to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause.
- Developed, design, and document ETL Process based on established standards and guidelines and CI/CD toolset such as JIRA, Confluence, BitBucket, Jenkins
- Automate ETL processes leveraging enterprise tools such as AutoSyst
- Provide operational and escalation support when required
- Document and communicate required information for deployment, maintenance, support, and business functionality.
- Work closely with business partners to help translate functional requirements into technical approach, design, and decisions.
- Create SQL schema objects, complex attributes / metrics, conditional and level metrics, and their use within a report
Top Must Have:
- Bachelor’s degree or equivalent in Computer Science, Computer Information Systems, Management Information Systems, Engineering (any) or related; and
- 5 years of progressively responsible experience in the Job offered or a related IT occupation.
- Working closely with business partners to help translate functional requirements into technical approach, design, and decisions- Banking & Markets business acumen;
- Developing Excel & Tableau dashboards and 3rd party application report integration;
- Using SQL, Python, Hadoop/Hive and data warehouse concepts /architecture, dimensional modeling, and ETL solution design.
- Tuning and optimizing query performance for large datasets-cubes, caching, aggregate structures within MicroStrategy, Tableau and various RDBMS, Hadoop backend systems.
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
Source : ICONMA, LLC