Tagcor

Data Engineer cum Developer

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, SQL Svr 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