Accountability
Typical Duties or Tasks
Design data models and data architecture, data governance
- Strong skills in SQL and data modeling
- Must be a creative thinker and self-starter, able to identify solutions and quickly prototype proof of concept. Expected to quickly understand and embrace new technologies
- Build deep expertise in the data and its meaning as it applies to business processes
- Strong inclination towards managing data with outlook on how to improve data quality, metadata management and data velocity
- Design and architect data solutions with Business intelligence and reporting in mind
- Architect DW / data-marts with industry best practices
- Analyze source data both from a technical and business perspective
Architect Information Systems and data delivery processes
Build strong knowledge of business data flow and data distributionDevelop logical data flow maps required for business analyticsEvaluate and recommend best practices for data collection, quality and distributionDesign and develop end to end information delivery processUnderstand business data needs and convert to technical specificationsIn-depth understanding of all critical business applications and its underlying data model / distributionAbility to recommend Business Value Drivers and KPIs needed by various business units for strategic, operational and predictive use casesDesign and architect system integration process needed for business analyticsDefine optimum joins between tables based on the functional requirementDesign and architect information solution
Strong knowledge of SQL and SQL queries :Hands on experience with complex SQL and high-volume Relational databases and SQL Query performance
Experience in replication, data warehouse and scalability - load balancingExperience to setup database alerts, maintenance plans and scriptsWorking knowledge on AZURE Databases including SQL AZURE, AZURE Data Warehouse, AZURE Data lakeAbility to design data models based on functional data / business requirementsConvert business requirement to end-to-end data flow, data model as part of the high level design
Apply sufficient business process knowledge to source system data to bring them into the logical datawarehosuseBuilt optimal data model with ease of access and heaving performance in mindStrong knowledge on various data modelling strategiesWorking closely with Business stakeholders to gather pain points build and / or extend the data model.
Supervise Data and Information test cases, resolve defects within BI toolsStrong knowledge of Informatica PowerCenter ETL toolPerform unit testing of ETLs and related components and document test results.
Experience with reading and loading high-volume Type 2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Star Schema)Create Unit Test Documentation (Test Cases, Test Scripts and Test Results)Experience working as a hands-on MS SQL Server 2005 / 2008 / 2012 / 2014 Database Administrator. DB and OracleDetermine and recommend enhancements to the BIDW for performance improvementExperience with advising and working with BI and advanced analytics technologies
Experience with the best of breed traditional enterprise Business Intelligence tools such asBusinessObjects
CognosMicrosoft Reporting ServicesExperience with best of breed high performance analytics tools such as :KNIMECloudera AnalyticsRapidminerExperience with statistical programming languages :PythonExperience with ETL tools such as :Flume
Informatica PowerCenterMS Integration Services (SSIS)Experience with best in breed analytics platforms such as :MS Analytics Platform (APS)
Hadoop (Hive and HBase)Windows AZURE platformSAP HANAExperience with Data Visualization tools such as :Tableau
QlikviewSAP LumiraTIBCO SpotfireEffective Business process translation and knowledge.
Managing the demand for new solutions against employee capacity.Knowledge on Railroad operational, maintenance, finance, sales and marketing.Basic IT Database and BI assets (data) and software (licenses, etc.) knowledge ensuring currency and compliance.Working closely with business leaders to assist in BI Technology roadmap, Proof of Concepts, Proot of TechnolodyRequired Skills :
Basic Qualification :
Additional Skills :
Background Check : Yes
Drug Screen : Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee : No
Exclusive to Apex : No
Face to face interview required : No
Candidate must be local : No
Candidate must be authorized to work without sponsorship : : No
Interview times set : : No
Type of project : Architecture / Design
Master Job Title : ETL Developer
Branch Code : Kansas City
