Data Warehouse Engineer Job Description
Data warehouse engineer
provides L1 & L2 support for AWS services like Lambda, Glue, Cloud formation, Bigdata tools like Hive, Hive Partitions as well as issues related to data mismatch for specific database and tables.
Data Warehouse Engineer Duties & Responsibilities
To write an effective data warehouse engineer job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse engineer job description templates that you can modify and use.
Sample responsibilities for this position include:
Being involved in the mobile ad industry, including participating in blogging, social mediums
Learning technologies such as Apache Hadoop, Apache Solr, Apache HBase, In-memory databases and
Requirement gathering and analysis to choose best technology for company needs
Interaction with various application teams requesting data warehouse solutions
Testing and adapting technology to suit customer needs
Planning product life cycle
Automation of deployments and upgrades
Lead the development team in areas such as application architecture and code performance
Design and development of high performing and quality ETL code in C#
Design, maintain and tune data warehouse databases in MSSQL 2012
Data Warehouse Engineer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse Engineer
List any licenses or certifications required by the position: MCSE, AWS, ITIL, CTS
Education for Data Warehouse Engineer
Typically a job would require a certain level of education.
Employers hiring for the data warehouse engineer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Technical, Information Technology, Mathematics, Education, Information Systems, Science, Computer Engineering, Business
Skills for Data Warehouse Engineer
Desired skills for data warehouse engineer include:
SQL
Dapper
Feature-driven development and Kanban
Hive
NHibernate
ORM tools like Entity Framework
RPC
SOAP
Service-oriented architecture and related architectural styles using REST
XML
Desired experience for data warehouse engineer includes:
Bachelor’s degree in computer science or related field is preferred, minimum of 4 years related IT experience, minimum of 2 years reports development experience
Guide extension and improvements for the SSAS data cubes
Troubleshoot suspected data problems and suggest changes and improvements to resolve potential issues
Apply knowledge of industry best practices and trends/developments to improve the current reporting infrastructure
Perform thorough testing and validations of changes and new data
Take ownership of development tasks and provide accurate time estimates, identify dependencies and risks
Data Warehouse Engineer Examples
1
Data Warehouse Engineer Job Description
Job Description Example
Our company is looking to fill the role of data warehouse engineer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse engineer
- This position involves the delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation
- The individual holding this position must be able to perform various complex assignments without much supervision
- Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, client’s or third-party’s reporting environments and dashboard
- Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, ) for all projects
- Design data structures (staging, intermediate staging, Dimension, Fact, Aggregate, views, ) well-suited to meet the business requirements
- Work with web analytics platforms such as Omniture and Google Analytics
- Harness data from real-time feeds and microservices leveraging AWS Kinesis, Lambda, Kafka, Spark Streaming, , recommend and design ideal data stores for different business purposes
- Design, develop, modify, debug and/or maintain software code according to functional, non-functional and technical design specifications
- Work within a team, collaborate and add value through participation in peer code reviews, provide comments and suggestions, work with cross functional teams to achieve goals
- Assume technical accountability for your specific work products within an application and provide technical support during solution design for new requirements
Qualifications for data warehouse engineer
- Responsible for ETL (Extract, Transform, Load) processes to bring data from multiple sources into a single warehouse environment
- An undergraduate degree is required, preferably in the Computer Science or Computer Information Systems
- Certifications in related technology products a plus
- Ability to design and implement medium to large projects using Informatica 9.x
- Experience with reporting and analytic tools and technologies such as MicroStrategy, Business Objects, Tableau, , is a plus
- 8+ years experience working with DB2 LUW in large DPF/Data Warehouse environments
2
Data Warehouse Engineer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of data warehouse engineer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse engineer
- Encourage to actively look for innovation and continuous improvement, efficiency in all assigned tasks
- Gain exposure to one of biggest DW of world
- Gain exposure to multiple lines of business (Cable/Mobility/fixed line) under same DW, nowhere in this line you will get exposure to such diverse line of business
- Be a part of a proud team to create dynamic solutions for business
- Executing unit tests and validating expected results
- Be escalation point for design, architecture, and development of Data Warehouse/Data Mart
- Ability to lead departmental development efforts - capturing knowledge capital, conducting internal training classes
- Mentorship of team members
- Build and manage scalable ETL pipelines to and from various internal and external data sources that come from a variety of systems (OLTP Databases, streaming data pipelines, text-based data files )
- Maintain enterprise Data Warehouse and ETL systems, security, SOX controls, backup & recovery, and SLAs
Qualifications for data warehouse engineer
- Exceptional management and people skills, ability to manage personnel activities of staff (e.g., hires, mentors, coach, trains, appraises, rewards, motivates, and disciplines, and recommends termination as necessary, 1-on-1's, Performance Reviews, of direct reports)
- Master’s degree or foreign equivalent in Electrical Engineering, Computer Engineering, or Electrical and Computer Engineering plus 4 years experience
- Providing ETL design, development, and testing estimations based business requirements
- High proficiency in dimensional modeling techniques and their applications Strong analytical, consultative, and communication skills
- Strong experience with Source Control (VSS, TFS, Subversion)
- Programming experience application or systems languages (Go, Python, Ruby, Java, C/C++, etc)
3
Data Warehouse Engineer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a data warehouse engineer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data warehouse engineer
- Establish and enforce Data Model, Data Warehouse, ETL, and BI standards
- Gather and review analytical needs of key groups such as Sales & Marketing, Finance and Manufacturing
- Train internal customers on available technologies
- Analyze, document, develop, integrate, and deploy analytics as per business needs
- Carry out monitoring and performance tuning in EDW, ETL and BI environments
- Identify emerging technologies and evaluate tools for current and future needs
- Assist in tuning the Microsoft PDW/APS, IBM Netezza, and Teradata platforms
- Operationalize the platform by transitioning knowledge to a service provider
- Provide Level three problem escalation support and troubleshooting
- Create and maintain technical documentation – operational runbook, standards, and supporting documentation
Qualifications for data warehouse engineer
- Experience building tools/infrastructure for data processing
- Experience and comfort in a Linux environment
- Well versed in software design patterns
- Master’s degree or foreign equivalent in Electrical Engineering, Computer Engineering, or Electrical and Computer Engineering and 8+ years experience
- 3+ years of experience as an Automated quality assurance engineer
- Experience with Test- and Behavior-Driven Development (Mocha, Chai, Cucumber)
4
Data Warehouse Engineer Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of data warehouse engineer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data warehouse engineer
- Setup and manage jobs in SQL Server Agent
- Write efficient code in Microsoft T-SQL and MDX languages
- Develop in SQL Server Data Tools, C# & .NET framework and use Excel Pivot Tables to perform analytics
- Lead delivery-focused data warehouse project team(s) to quality & timely deliverables
- Design and develop Data Warehouse database schema(s) & structures
- Design and develop Data Warehouse Cubes – Dimensional, Tabular, Relational, and Multidimensional OLAP cubes
- Develop and maintains policies, standards, and guidelines to ensure that a consistent framework is applied across the company
- Researches leading edge capabilities to determine the best solution fit for the overall environment
- Sets technology architectural direction, and delivers technology architectural assessments recommending (replace, retire, maintain) strategies
- Review and provide architectural guidance for all analytics solutions
Qualifications for data warehouse engineer
- Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving
- Experience with .NET technology (VB.net, C#, ADO.net)
- Certifications (Microsoft, TDW, PMP, ) a plus
- Experience with data warehousing and star-schema (dimensional) data models a plus
- Strong scripting skills - python ( a big plus ), Perl , shell
- Strong programming/scripting background with extensive knowledge of Unix/Linux (e.g., shell,python/perl/ruby and bash/korn )
5
Data Warehouse Engineer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of data warehouse engineer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehouse engineer
- Design and deliver testing solutions for data warehouse code
- Build cutting edge mixed workload data warehouse solutions as the foundation of all BI activity at Health Equity
- Actively engage in risk identification, action planning and mitigation strategy
- Collaborate with software engineers and business experts to conduct data discovery expeditions to gain an understanding of complex business logic
- Collaborate with software engineers and business experts to gain an understanding of complex business logic
- Be an effective listener, who can give timely and constructive feedback
- Collaborate with BI developers and product managers on delivery of reporting initiatives
- Perform query tuning and assist reporting engineers in designing and performance tuning their queries
- Troubleshoot production support issues in the reporting environment
- Extract data from disparate sources and transform into internal formats for loading into our platform
Qualifications for data warehouse engineer
- Minimum of 5 years professional experience in a technical/data analyst role in a data driven environment
- Minimum of 3 years of professional experience in ETL development and Microsoft SSIS and SSRS
- Ability to synthesize technical requirements or processes into layman’s terms
- Ability to import/ export data to and from a Database system
- Strong sense of urgency and ability to engage the right groups to support the ask
- Ability to integrate Full Data sets into various Database Architecture and model data and design database architecture