200+ applicants
Windsor Solutions · 3 days ago
Data Analyst/Developer
Northampton, MA
Full-time
Hybrid
Mid Level
3+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesEnvironmental ConsultingInformation Technology
Insider Connection @Windsor Solutions
Responsibilities
Developing ETL (extract/transform/load) routines to migrate data from existing client systems into Windsor-developed products.
Supporting existing clients by troubleshooting and correcting issues in database objects (procedures, functions, triggers).
Developing new database objects to enhance product functionality.
Communicating effectively with stakeholders such as business analysts, clients, and team members to gather and define business requirements.
Conveying technical concepts to non-technical individuals and merging business requirements into project architecture.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Minimum 3 years experience as a data analyst
Microsoft SQL Server development (stored procedures, SQL queries, performance tuning)
Expert knowledge Extract, Transform, Load (ETL) processes and tools
Knowledge of how to retrieve, process, and migrate data from disparate client source systems which are stored in a variety of file formats, DBMSs, and file systems
Ability to move and transform that data into the Windsor target proprietary platform
Develop code using PowerShell and T-SQL
Communicate technical details with the team and client
Have an understanding of data models which may include relational, dimensional, entity-relationship, logical and physical and the conversion between logical to physical
Bring SQL Server operational experience – not necessarily at DBA level – but at a functional level. This experience includes basic administrative knowledge such as backup, recovery, moving, partitioning, and both logic and performance enhancements
Experience in requirements gathering with diverse stakeholders, documenting decisions and providing status updates as needed
Be able to translate technical concepts and findings into clear and actionable insights for non-technical audiences
Work closely with product owners and developers to implement product improvements at the database level
Demonstrate resourcefulness in problem-solving and balance independence with escalation when needed
Company
Windsor Solutions
Windsor Solutions expertise in developing, building and strengthening digital ecosystems with modular solutions for environmental agencies.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
