Analytics Developer

Vensai Technologies; Atlanta (GA); Remote; USD 105,000 - 196,000; Full time

Job summary

A government department seeks a senior analytics developer in Atlanta to design and support ETL programs for their data warehouse. Candidates must have extensive experience with BI tools like Power BI, as well as strong programming skills in SQL and Informatica. This role emphasizes problem-solving, effective communication, and the ability to mentor others.

Qualifications

• 6 to 7 years of experience with Power BI, IDMC, BigQuery, and Python.
• Experience in designing and developing complex Informatica mappings and workflows.
• Effective communication skills required.

Responsibilities

• Design, develop, test, maintain, and support complex ETL programs for an Enterprise Data Warehouse.
• Contribute to testing and deployment of reporting components.
• Perform data and root cause analysis.

Skills

Data analysis

Problem-solving

Advanced SQL

PL/SQL

Informatica

Power BI

Data Warehousing

Python

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

IDMC

BigQuery

Oracle RDBMS 19c

Job description

1 week ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Vensai Technologies

Atlanta, GA 30334 Remote

12+Months

TheGeorgia Department of Human Services (DHS) is seeking qualified candidates forthe senior analytics Developer positionin Atlanta, Georgia.

The desired candidate will design, develop, test, maintain, andsupport complex data extract, transformation, and load (ETL) programs for anEnterprise Data Warehouse. Understanding how complex data should be transformedfrom the source and loaded into the data warehouse is critical to this job.

• Expertiseand solid experience in BI Tools – Power BI and BigQuery
• StrongIDMC(Informatica) technical knowledge in the design, development, andmanagement of complex Informatica mappings, sessions, and workflows
• Strongprogramming skills, relational database skills with expertise in Advanced SQLand PL/SQL, indexing, and query tuning
• Experiencedin Business Intelligence and Data warehousing concepts and methodologies.
• Contribute to the design and implementation of the solution's metadata, ETL, and reporting components, including testing and, at times, deployment.
• Extensiveexperience in data and root cause analysis and proven problem-solving andanalytical thinking capabilities.
• Analyticalcapabilities to slice and dice data and display data in reports for the bestuser experience.
• Demonstratedability to review and translate business processes into BI reporting andanalysis solution
• Abilityto follow the Software Development Lifecycle (SDLC) process and should be ableto work under any project management methodologies used.
• ·Abilityto follow best practices and standards.
• ·Abilityto identify and tune BI application performance bottlenecks.
• ·Abilityto work quickly and accurately under pressure and project time constraints
• ·Abilityto prioritize workload and work with minimal supervision
• Basicunderstanding of software engineering principles and skills working onUnix/Linux/Windows Operating systems, Version Control, and Office software
• ExposureData Modeling using Star/Snowflake Schema Design, Data Marts, Relational andDimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensionaltables, Physical and Logical data modeling
• Produce client deliverables such as detailed design documentation, configuration documentation, unit test plans, and training curriculum

Required Qualifications:

• A bachelor's degree in Computer Science or a related field
• 6 to 7 years of experience working withPower BI, IDMC,BigQuery and Python
• Ability to design and develop complex Informatica mappings, sessions, and workflows and identify areas of optimization
• Experience with Oracle RDBMS 19c
• Effective communication skills (both oral and written) and the ability to work effectively in a team environment are required.
• Proven ability and desire to mentor/coach others in a team environment
• Strong analytical, problem-solving, and presentation skills.

Preferred Qualifications:

• Working knowledge of Informatica Power Exchange/Power Center and IDMC
• Experience with relational, multidimensional, and OLAP techniques and technology
• Experience with Visualization tools like MS Power BI, Tableau
• Experience with BigQuery and Python.

Soft Skills:

• Strong written and oral communication skills in the English Language.
• Ability to work with Businesses and communicate technical solutions to solve business problems.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Contract

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Vensai Technologies by 2x

Sign in to set job alerts for “Developer” roles.

Atlanta, GA $105,100.00-$195,200.00 10 hours ago

UI Developer - Front End Engineer - 100% REMOTE W2 Only

Associate Software Development Engineer, Crew

Atlanta, GA $134,437.33-$182,450.66 1 month ago

Atlanta, GA $134,437.33-$182,450.66 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.