Candidate under this WOC will participate in executing the strategic direction for use of data to support CW programmatic and administrative functions. Candidate will provide expertise in the planning efforts to identify and modernize the agency’s data assets and to develop the future-state technical environment for CW.
Tasks
Candidate shall:
- Develop database structure and process changes based on specifications established during weekly Sprint planning sessions and following data standards based on existing datatype standards where available and appropriate; address standards published by the United States Postal Service as an example.
- Comply with data security and access models.
- Comply with Federal regulations for CCWIS (Comprehensive Child Welfare Information System) design, development, deployment, and maintenance.
- Follow a data (or database) change request process with the developer and Data Resource Management teams.
Required Skills And Experience
- Microsoft Azure Development Operations
- Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years of experience)
- Microsoft Visual Studio (10+ years of experience)
- Microsoft .NET framework (4-5 years of experience)
- HTML DOM (7-9 years of experience)
- Windows 9x/2000/XP/NT/Vista/7 (7-9 years of experience)
- Design patterns (7-9 years of experience)
- Transact-SQL (10+ years of experience)
- Data Analysis (10+ years of experience)
- JSON (10+ years of experience)
- SQL (10+ years of experience)
- MVC (4-6 years of experience)
- XML (4-6 years of experience)
- C# (4-6 years of experience)
- HTML (4-6 years of experience)
- JavaScript (4-6 years of experience)
- TCP/IP (4-6 years of experience)
- Communication skills both verbal and written (4-6 years of experience)
- Microsoft Office (4-6 years of experience)
Data Architect
ABOUT THIS ROLE: The Data Engineer / Architect will collaborate directly with the Digital Analytics team within Enterprise Analytics & CX to design, document, build, and refine a scalable data framework to support digital reporting & analytics.
JOB DESCRIPTION:
Designs and builds relational database models and defines data requirements to meet the business needs. Foster value creation from the use of the internal organization’s data assets, as well as from the external data ecosystem. Source the value through envisioning data-enabled strategies as well as enabling all forms of business outcomes through analytics, data and analytics governance, and enterprise information policy.
ESSENTIAL FUNCTIONS:
– Defines and documents data requirements to meet business needs
– Designs & builds data pipelines to move decentralized data into a common data warehouse
– Develops logical and physical database models. Writes ETL scripts and commands
– Participates in data product design recommendations that span the data warehouse and reporting layers
– Analyze and organizes raw data to be translated into usable data tables for consumption
– Review & resolve database performance, capacity, data integrity, and replication issues.
– Responsible for data governance, ensuring accuracy, integrity, and consistency of data definitions across the data warehouse
– Sustains knowledge of current trends as it relates to data analytics
– Recognizes the strengths and weaknesses of various data sources; works with stakeholders to recommend utilization of specific data sources to most effectively capture desired information
– Influences the data architecture and communicates to various data leaders to share the advantages of design change
RESPONSIBLITIES:
1. Works with data leaders to define & document data requirements to meet business needs.
2. Reviews current data model and performance and recommends changes to improve
3. Builds new & reconstructs current engineering data pipelines
4. Designs a high-performant reporting model for fast analytics
5. Applies data governance best practices end to end (e.g., code documentation, metric definitions, table metadata, data quality checks)
Required Skills:
– Experience in scripting for automation using SQL, including experience writing DML and DDL statements
– – 5+ years
– Experience in data warehousing and data modeling – 5+ years
– Experience designing Power BI semantic models – 2+ years
– Experience with GitLab or GitHub – 1+ years