• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 22nd Sep 2021

Our IT department is currently seeking an experienced data engineer to build data pipelines
that provide peace of mind for people by equipping them to make data-informed business decisions.

·         Develop reliable, reusable, automated and streamlined ETL code

·         Design and develop BI data marts, reports and dashboards

·         Create reconciliation procedures and data checks to ensure data quality

·         Build in automated audit, balancing and controls 

·         Proactively conduct data investigations and assist business partners with complex data analysis and
ad-hoc queries

·         Lead application and technical architecture analysis, design and implementation, and ensure BI
product fulfills requirements

·         Develop BI application products and deliverables throughout development life cycle, including model
prototype design in Framework Manager and other design and development activities with the
Cognos toolset at an expert level

·         Lead efforts with Data Management and database specialists to troubleshoot and report issues

·         Design new reporting applications to ensure reporting requests can be supported by the underlying
data source

·         Expertly understand configuration dependencies and interrelationships between Cognos and other
data warehouse and business intelligence tools and designs; troubleshoot in the area with this
knowledge

·         Provide alternatives based on best practices for business intelligence and Cognos toolset functionality
leading conversion of legacy artifacts

·         Proactively identify, build, and maintain relationships with business process owners and colleagues

·         Identify changes in scope or work effort that could result in budgetary overrun or missing of delivery
date, design and implement contingency

Requirements:
expert-level expertise with SQL, Data Modeling and Dimensional Modeling
proven experience distilling business requirements into data warehouse design artifacts such as a
Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models
experience with Test Driven Development (TDD)
experience in: designing and implementing ETL processes (preferred tools:  IBM's DataStage,
SQLSvr SSRS, SAS); developing BI dashboards (preferred tools:  IBM's Cognos, Microsoft's Power
BI); creating data quality scorecards and data lineage
experience leading agile teams
mentor development team members in design and development of BI solutions

strong team working skills, an analytical nature, self-motivated and excellent written and oral
communication skills
ability to comprehend complex technical and logical concepts and adapt quickly to changes
ability to maintain own workflow and meet deadlines while managing parallel project deliverables with
minimal direction
ability to create effective visual models to enable collective understanding of processes, data flow,
user interaction and others as needed
prior reporting application support experience
track record of successfully architecting small, medium and enterprise-scale solutions
preferred three or more years of business requirements experience
preferred three or more years of hands-on experience developing and supporting a BI/reporting
application like Cognos, Hyperion, Business Objects