IT Business Intelligence Developer - Level 3 - Remote - HCL Global Systems Inc.
Hartford, CT 06103
About the Job
| Type | Category | Qualification | Description | Competency | Required | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Skills | Database | Data Analysis | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Database | Data Modeling | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Database | Data Warehousing | Novice (1-3 Years) | No | ||||||||
| Skills | Database | Microsoft SQL Server | Novice (1-3 Years) | No | ||||||||
| Skills | Database | MySQL | Novice (1-3 Years) | No | ||||||||
| Skills | Database | PostgreSQL | Novice (1-3 Years) | No | ||||||||
| Skills | Database | Transact-SQL | Novice (1-3 Years) | No | ||||||||
| Skills | Design | User Experience Design (UX) | Novice (1-3 Years) | No | ||||||||
| Skills | Languages | PL/SQL | Novice (1-3 Years) | No | ||||||||
| Skills | Languages | Python | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Languages | SQL | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Others | Business Intelligence Analyst Planner | Proficient (4-6 Years) | No | ||||||||
| Skills | Others | Communication skills both verbal and written | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Others | Data Analytics Specialist | Proficient (4-6 Years) | Yes | ||||||||
| Skills | Others | Data center management | Novice (1-3 Years) | No | ||||||||
| Skills | Others | Enterprise Data Architect | Proficient (4-6 Years) | No | ||||||||
| Skills | Others | Online Web-based Training Developer | Novice (1-3 Years) | No | ||||||||
| Skills | Others | Presentation skills | Proficient (4-6 Years) | No | ||||||||
| Skills | Others | Process Flow Analysis | Novice (1-3 Years) | No | ||||||||
| Skills | Others | Project management | Novice (1-3 Years) | No |
NOTE: This is a remote position.
VENDORS: Please read the role description carefully, as this position requires a highly-skilled candidate. Any submission that does not match the requirements will not be considered.
This is Us
The State of Connecticut is leading a new digital transformation in government to uplift the lives and well-being of our residents, businesses, and employees. Our goal is to improve access to our programs and services, making interaction with government easier. When you join the Connecticut Digital Service, you'll be part of a team creating simple experiences personalized for everyone. If you enjoy solving complex problems with a curious, supportive, high-performing team, then the State of Connecticut is the place for you.
Is This You?
Big Thinker. You see data as a means for reaching strategic goals and can use data to impact both the business and the customer.
Problem Solver. You recognize the critical role data plays in understanding and solving pain points.
Organically Curious. You see beyond the obvious to identify and fill-in the missing data and gaps of understanding
Service-Oriented. You are passionate about government innovation and improving services for your fellow citizens.
About the Role
The Data Analytics and Strategy Lead will be a key player in establishing a robust, scalable, and accessible data practice for the State of Connecticut. This role requires a unique combination of technical expertise, strong analytical skills, and a highly strategic mindset to drive awareness and adoption of data and analytics. This person will maintain and expand on existing data structures including pipelines, databases, and dashboards, while also helping to build a sustainable data practice that drives government-wide optimization.
You will guide teams in leveraging data to improve the end-to-end user journey, identify product and service challenges, and foster a culture where data is integrated into everyday operations. You will also ensure the integrity, uptime, and accessibility of data technology to support the state's initiatives.
You must have a deep understanding of data modelling, user research, data analysis, visualizations, and the strategic application of data to improve service delivery at every stage of the customer lifecycle. You will need to have a strong background in quantitative/qualitative data management, data research methodologies, data engineering, data analysis, and executive-level communication skills to be successful in this role. There will be a heavy emphasis on Google Analytics, Google Search Console, Power BI, and other behavioral metric systems.
Note: This is a full-stack data position, which requires a cross-functional skillset in engineering, analysis, and strategy. Do not apply if you do not have proficiency in each of these areas.
Key Responsibilities
- Data Strategy and Leadership:
- Help lead the development and execution of the state's data practice, focusing on clear and actionable strategies and aligning with organizational goals.
- Work closely with stakeholders to identify critical data needs and design solutions that address them.
- Mentor and guide non-technical teams to build their confidence and capability in using data for decision-making.
- Analysis and Insights:
- Collect, compare, and analyze complex data sets to identify trends, patterns, and actionable opportunities.
- Present findings in clear, visually engaging formats tailored to audiences with varying levels of data literacy.
- Create detailed reports, dashboards, and presentations that drive organizational improvements and adoption of insights.
- Technical Maintenance and Expansion:
- Maintain and optimize existing pipelines, databases, and Power BI dashboards currently in use at the State.
- Develop and implement strategies to scale data systems as needs grow, ensuring performance and data integrity.
- Oversee ETL processes to integrate data from new sources and improve workflows.
- User Engagement and Enablement:
- Design and deliver training programs to help non-technical teams incorporate data and analysis into their regular workflows.
- Collaborate with teams to develop KPIs and frameworks for measuring the impact of data-driven initiatives.
- Facilitate workshops, office hours, and regular program updates to ensure alignment across teams.
- Cross-Functional Collaboration:
- Partner with leadership, IT teams, and other stakeholders to identify priorities and implement solutions.
- Act as a liaison between technical teams and business stakeholders, ensuring alignment and understanding.
Experience Required for This Role
Data Collection & Analysis at least 3 years of measurable experience in the following:
- Analyzing user data and metrics to drive specific business goals
- Using data to isolate problems and develop solutions
- Utilizing predictive analysis, gap analysis, quantitative reporting, user research, and statistical analysis
- Providing insights and recommendations based on data
- Bridging the data divide between technical, product, and customer-facing teams
- Developing and applying data models to improve the collection and analysis of data
- Crafting compelling presentations and narratives from data findings. Emphasis on Power BI dashboards
- Engaging in data experiments that provide cross-persona or enterprise-level analysis
- Data cleansing, optimizing, and ETL
- Developing and analyzing user surveys
- Organizing and storing data and queries for easy access in future work projects
- Documenting data collection and analysis procedures
- Preparing and executing ROI analysis
Technical Expertise at least 3 years of measurable experience in the following:
- Managing data pipelines, ETL processes, and databases (e.g., SQL, Power BI, Azure Data Lake)
- Proficiency in Python or R for data manipulation and analysis.
- Data modeling, data governance, and data quality best practices
- Administering analytics software and platforms (GA, GTM, SPSS, Excel, Microsoft Office Suite)
- Using business intelligence tools like Tableau or Power BI
- Data collection from on-prem and cloud platforms like Microsoft, Azure, and Salesforce
- Leveraging statistical analysis and algebra
- Leveraging economics, business/systems analysis, and quality assurance
- Manipulating large, complex data sets
- Documenting data processes and configurations
Strategy, Communications, and Governance at least 3 years of measurable experience in the following:
- Developing a data practice that incorporates strategy, training, tool development, and support
- Communication and collaboration with cross-functional teams and government partners
- Crafting compelling presentations and narratives from data findings
- Explaining data analysis to stakeholders with varying levels of data comprehension
- Using data to help internal teams improve capabilities and operations
- Training non-technical teams on data analysis and its real-world application
- Performing competitor research to help improve products and services
- Researching latest market trends and implementing knowledge
- Organizing focus groups and feedback loops to establish data collection
- Establishing and integrating appropriate KPIs to help track success
- Improving research or data management environments
- Establishing standardized testing of products/services using data
- Ability to juggle multiple project workstreams
- Ability to maintain strict confidentiality
- Judgment in dealing effectively and diplomatically with all levels of government staff
Other Preferred Skills & Qualifications
- Deep domain knowledge for a particular industry especially Health, Business, or Education
- Experience with behavioral or CRM-related metrics platforms
- Bachelor's degree in computer science, business, IT, management, administration, economics, or information science
- Experience with machine learning, AI, and cognitive service engine models
- 2 years experience with Power BI or other data visualization platforms
- 2 years of user research and feedback analysis
- 2 years of data governance and working within data security groups
- 1 year of API development
- 1 year of marketing experience, supported through metrics
- 1 year of project management experience
- 1 year of experience with customer relationship management platforms such as Salesforce
- 1 year of experience with web content management platforms such as Sitecore
Source : HCL Global Systems Inc.