DOH is looking for a Technical Specialist 1/TS1 for a 402-hour assignment. Extensions are likely, but budget is set and initial duration is limited to 402 hours for the time being.
Posting will close to submissions on Monday, 9/19 at 2pmEST
Onsite interviews are highly preferred, and local candidates available to interview onsite will be considered first. Utilize the bid comment section to explain each candidate's situation!
Please also note start date, of 10/2, as a PO at DOH can take 3+ weeks to create, after a candidate has been selected. Set this expectation with the Candidate prior to submitting.
Technical Specialist 1/TS1
1208 hours (end date 4/28)
Description of Duties:
25% of Total Work Effort: Requires 5-7 years’ experience as an SSIS ETL Developer working in Microsoft SQL Server
25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems
25% of Total Work Effort: Strong cube/analytical data model design expertise (preferred)
25% of Total Work Effort: Snowflake and Star Schema design
The SSIS ETL Developer is responsible for designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners.
The SSIS ETL Developer is responsible for data profiling of new source systems, designing custom reporting tables (such as fact and dimension), and using SSIS to create ETL packages to fully support reporting solutions in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS required).
The Resource must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives.
Must have:
• 5-7 years of experience as an SSIS ETL developer
• Data profiling and data modeling experience
• Strong in data warehousing concepts and techniques
• SQL, T-SQL, PL/SQL techniques
• Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension)
• Snowflake and Star Schema design
• Effective verbal and written communications skills and effective presentation skills
• Self-motivator, independent, cooperative, flexible, creative
Preferred:
• Strong OLAP/cube/analytical data model design expertise
• Cognos experience
MINIMUM REQUIREMENTS
• Bachelor’s degree in Computer Sciences or Computer Engineering or associated discipline or the equivalent experience.
• Microsoft Certified Solutions Developer (MCSD) certification is a plus
• Knowledge of administration of SQL Server for transactional and analysis systems
• Strong cube/analytical data model design expertise (preferred)
• Specific knowledge of Software Deployment Requirements for BI/DW Projects (preferred).
• Effective verbal and written communications skills and effective presentation skills.
• Self-motivator, independent, cooperative, flexible, creative.
Essential Duties and Responsibilities
• Designs, develops and monitors Enterprise Transformation Language (ETL) processes using SSIS
• Performs data profiling, ETL development and administration, and release management
• Data modeling using modeling tools and methodologies
• Gathering, documenting, and designing data requirements
• Strong quantitative and analytical skills with accuracy and attention to detail
• Ability to work well independently with minimal supervision, manage multiple priorities, and remain flexible in a dynamically changing environment.
• Establishes and implements standards and strategies for data management, lifecycle, and quality
• Defines and implements best practices and standards for the data modeling processes.
• Creates and maintains the logical and physical data models for the production and Business Intelligence Data Warehouse and Data Marts.
• Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team.
• Develops prototype views and works with business users both internal and external to refine their requirements.
• Demonstrates self-reliance in researching technical solutions and product functionality.
• Continuously improves existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions.
• Monitors production support issues and develops corrective solutions.
• Conducts performance tuning of existing data structures.
Data Profiling:
We currently are pulling data from a few source systems and are gathering requirements for dozens of new dashboards, each from at least one (and maybe more) source systems. Each dashboard project will require data profiling, ETL, and report development work. On some projects, the ETL developer will take on the data profiling responsibilities in addition to the actually ETL work itself. This involves working with the business analyst, end-user, report developer, and maybe the technical subject matter expert. The Resource must have strong experience creating reporting tables. The reporting tables created will contain the business logic required for the reports, so that the calculations are performed during ETL. There will be reporting tables created for each dashboard project. The ETL Resource needs to have strong SQL skills in order to optimize the table builds, in addition to reviewing and optimizing the SQL code of other developers.
ETL Development:
Create ETL packages and jobs to pull data from source system and also create reporting tables (such as fact and dimension). Resource must have experience with data warehousing techniques, including aggregates and slowly changing dimensions. Create new ETL jobs and tune existing ETL jobs. Review code from other data modelers and make recommendations for changes in order to improve performance. Create indexes for tables which are being pulled in as needed.
Administration
Administer ETL system by setting-up new data sources, monitor performance of ETL jobs and resolve all issues, communicate any issues to team and business users, implement practices to mitigate issues, and work with DBAs as needed to investigate any data source connection issues. Schedule ETL jobs to run at optimal times as to not interfere with live operational data, yet pull the most current data. Set-up notification emails to monitor success or failure of ETL jobs. Communicate status of ETL jobs to team and mentor other developers on how to resolve issues. Monitor ETL sequence and make changes as needed. Mid-day data refresh as needed in Development and Production environments. Coordinate Cognos read access to Data Warehouse data sources.
Monitor Growth:
The data housed in our data warehouse will be growing exponentially, and in a short time frame. This Resource will be responsible for tracking the growth rate and keeping the team and management updated on any hardware changes and recommendation so that our systems can handle our growth.
Release Management:
Selected Resource will learn and follow our release management process. This includes identifying the schedule in which the deployment needs to occur (standard release, non-standard release, or emergency release). The ETL Resource will be responsible for identifying the database rollback process for each database deployment.
