Data Analyst/Developer - Hybrid - with Gov Exp
MSYS Inc.
San Francisco, United States of America
12 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
San Francisco, United States of America
Tech stack
Microsoft Word
Microsoft Excel
API
Data analysis
Cloud Computing
Computer Programming
Data Dictionary
Data Files
ETL
Data Security
Data Warehousing
Digital Content
R
Machine Learning
Microsoft Office
Microsoft Visio
Microsoft Software
Oracle Data Service Integrator
Power BI
Standard Sql
SAS (Software)
SQL Databases
Systems Integration
Talend
Informatica Powercenter
Snowflake
Microsoft Fabric
Digital Government
Data Analytics
Requirements
- 5+ years as a data specialist, analyzing, designing, developing and maintaining optimal data models and pipelines:
- Analyzing and developing data models and data dictionaries for data warehouse and data analytics integration
- Assembling large, complex data sets that meet business requirements
- Building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, SAS, Power BI and cloud-based technologies
- 5+ years of experience with principles and techniques of analyzing and documenting all product life cycle artifacts such as functional requirements, business cases, project charters, communication plans, test plans, detailed functional specifications
- Prior experience implementing large scale multi-organizational data warehousing solutions using ETL tools, Machine learning, and Data APIs
- 5+ years of experience analyzing data using SAS
- 5+ years of experience analyzing data using Power BI
- 5+ years of experience in data modeling
- 5+ years of programming experience in SQL
- 5+ years of experience using an enterprise grade ETL/ELT product (i.e., Talend, Informatica, Oracle Data Integrator, etc.)
- Strong understanding of data classifications, data access and security
- Proven track record of written and verbal communication skills, with both technical and non-technical audiences
- Experienced working with project schedules, identifying deliverables, milestones, and timelines for assigned projects
- Confidence explaining decisions, analyses, and recommendations to stakeholders of varying levels of seniority and digital content knowledge
- Great inter-personal skills, flexible can-do attitude, and drive for continuous improvement
- Ability to assess and evaluate situations and identify creative problem-solving solutions
- Experienced with MS Office applications including Word, Excel, Project, and Visio
- Knowledge of digital government and digital government strategies
- Ability to communicate clearly and effectively in English, both orally and written
- Additional Skills/Qualifications Desired
- Proficient in Microsoft applications
- Recent experience within government agencies or public-sector bodies with projects of a similar type
- Experience integrating, supporting and administering Snowflake
- Experience using Talend Data Fabric, R, and Power BI