ETL Developer

  • Free
  • Published date: July 11, 2020
    • Ontario, Canada

Positions:  Enterprise Data Warehouse ETL Developer
Interview: Two step interview process and Skype interview

Initially remote later onsite

 

Candidates must have at least 5 years of Development experience and must be
able to come to the Client building in person (Washington, DC) to pick up a
laptop. They will not ship out a laptop to anyone.

 

LENGTH OF EXPERIENCE

8+ years

 

TECHNICAL EXPERIENCE REQUIRED (IN YEARS)

Knowledge of Relational Databases ? 8 years

Knowledge of Dimensional Model (Erwin, ER Studio) - 8 years

SQL Server management Studio ? 8 years

SQL Server Analysis Services, Reporting Services and Integration Services ? 8
years

Requirements Gathering ? 8 years

SQL Programming ? 8 years

Business intelligence technologies and solutions - 5 years

Data Profiling ? 5 years

 

Top 3 skills/ How are they applied?

Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon,
star schema, snowflake schemas, and normalized and de-normalized data models)

technical team lead in the development of business intelligence reports and
analysis

Expert SQL skills

 

ESSENTIAL DUTIES:

Serve as technical team lead in the development of business intelligence
reports and analysis, providing mentoring, guidance and troubleshooting to
analysis team members in solving complex reporting and analytical problems

Manage reporting environment including report data sources, security,
subscriptions and metadata

Assist in initiative towards data normalization and data integrity across the
enterprise

Assist Data Warehouse Engineer in identifying and revising enterprise
reporting requirements

Evaluate, test and implement new or upgraded software

Troubleshoot reported problems pertaining to reports and the reporting
database environment, working closely with other IT members, especially DBAs,
Systems Analysts and Systems Engineers, identifying the cause and designing or
developing an approach for resolution

Assess impact of changes and updates to source production systems, planning
and implementing resulting changes to reports

Conduct end user training on reporting system

Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon,
star schema, snowflake schemas, and normalized and de-normalized data models)

Leads the integration of the data warehouse with a modern, leading business
intelligence platform

Leads in designing and revising data model for data warehouse, and meta data
and data dictionaries across the enterprise

Develops and maintains a thorough knowledge of business processes supported
by software systems/products

Analyzes and documents ?as-is? and ?to-be? scenarios (processes, models, use
cases, plans and solutions)

Performed Source system analysis (SSA) to identify the source data that needs
to be moved into the target tables

Perform Data Analysis and Data validation by writing SQL queries

Innovating new ways to standardize existing data processes and optimizing
current workflows

Creating custom data sets for use within our Analytics teams

Create Data Mapping documents, data dictionaries and Interface Control
Documents (ICDs)

Works as part of Scrum Development Team and effectively participates in
sprint planning, task estimates, task sequencing, task assignments, sprint
reviews and retrospectives.

Meets and collaborates with business users on requirements and objectives

Leads in reviewing and revising database designs and scripts on an ongoing
basis

Leads in documenting meta-data about Data Warehouse System according to
computer industry standards and knowledge of database management systems.

Manages data loads, and security, storage and performance strategies and
implementations.

Serves as technical team member in the development of business intelligence
reports and analysis, providing mentoring, guidance and troubleshooting to
analysis team members in solving complex reporting and analytical problems

Conducts complex analyses of strategic issues based on analysis of trends and
interrelationships of key performance drivers documented in the data warehouse,
especially the identification of test and control groups and comparison and
evaluation of their relative performance; synthesizes research results and
develops actionable strategic recommendations; communicates research results
and strategic recommendations to nationwide and division strategy managers.

Devises ER diagrams and identifies unique foreign keys, entities, attributes,
relationships and business rules for data warehouse

 

EDUCATION:

Bachelor's Degree

A Bachelor's Degree in Computer Science and/or Information Technology or
Software Engineering; relevant work experience (over eight years) may be
acceptable.

 

DESIRED QUALIFICATIONS

Creating visual displays for data analysis and presentation

Tableau Reporting Server

Experience with high performance big data concepts, such as Hadoop
architectures and columnar databases such as Vertica

Experience with solution delivery frameworks and tools such as Agile, Scrum,
Kanban, JIRA

 


Reference : ETL Developer jobs

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"


post to multiple job boards
Now take benefits of multiple job boards and search engine posting.
Try it.

Related listings