Technical Specialist - Senior - High

Skills Skills Required Required Experience Candidate Experience Last Used Strong hands on experience with Python Required 7 Years Proficiency with Power BI Required 5 Years Strong SQL skills and experience working with relational databases (SQL Server, PostgreSQL, Oracle, MySQL, Ingres) Required 7 Years • Senior level experience writing optimized SQL queries and analyzing existing SQL queries for performance improvements Required 7 Years Solid understanding of SOAP/REST APIs, backend architecture, and microservices Required 5 Years Experience designing and executing data migration or data conversion projects Required 7 Years Understanding of data governance, security, and compliance requirements Required 7 Years Familiarity with legacy system migration projects Highly desired 5 Years Experience with large-scale migration or modernization initiatives Highly desired 5 Years Experience with Java development Highly desired 5 Years Experience with cloud platforms (AWS, Azure, GCP) Desired 3 Years Knowledge of Power BI administration, workspaces, gateways, and deployment strategies Desired 3 Years Experience with version control (Git/Subversion) and CI/CD pipelines Desired 3 Years Experience with Perl for scripting, system utilities, or legacy app maintenance Nice to have 3 Years Experience developing/maintaining applications Zope application server Required Experience developing/maintaining Plone CMS applications Required . Client is seeking a skilled Applications Systems Python Developer to design, develop, and support data pipelines, dashboards, integrations, and migration processes across enterprise systems within the Office of the NC Chief Medical Examiner.

Client is seeking a skilled Applications Systems Python Developer to design, develop, and support data pipelines, dashboards, integrations, and migration processes across enterprise systems within the Office of the NC Chief Medical Examiner. 

Client is seeking a skilled Application Systems Python Developer to design, develop, and support data pipelines, dashboards, integrations, and migration processes across enterprise systems within the Office of the NC Chief Medical Examiner. This role plays a key part in moving data between legacy and modern platforms, ensuring data quality, and enabling analytics and automation through Python and Power BI.
Key Responsibilities:
• Develop and maintain data migration scripts, ETL pipelines, and automation workflows using Python
• Design, build, and optimize data models for reporting and analytics
• Create interactive dashboards, reports, and analytics solutions using Power BI
• Perform data extraction, transformation, validation, and loading between databases, APIs, and enterprise systems
• Optimize data processes for speed, reliability, and scalability
• Work with SQL queries, stored procedures, and database objects to support migration and reporting
• Integrate data from multiple sources, including cloud apps, on premises systems, and flat files
• Collaborate with business teams to define reporting needs and translate them into technical solutions
• Analyze data quality issues, reconcile datasets, and implement best practices for data integrity
• Implement automation for recurring data tasks and reporting workflows
• Maintain documentation for data processes, source mappings, and migration steps
• Participate in architecture, design, and planning sessions for data modernization projects
Required Skills & Experience:
• Strong hands on experience with Python
• Proficiency with Power BI
• Experience designing and executing data migration or data conversion projects
• Strong SQL skills and experience working with relational databases (SQL Server, PostgreSQL, Oracle, MySQL, Ingres)
• Understanding of data governance, security, and compliance requirements
• Strong troubleshooting ability and attention to detail
Preferred Qualifications:
• Experience with cloud platforms (Azure, AWS, or GCP)
* Experience with Java development
• Experience with version control (Git/Subversion) and CI/CD pipelines
• Knowledge of Power BI administration, workspaces, gateways, and deployment strategies
• Experience with large-scale migration or modernization initiatives

Skills

Skills	Required	Required Experience	Candidate Experience	Last Used
Strong hands on experience with Python	Required	7		Years
Proficiency with Power BI	Required	5		Years
Strong SQL skills and experience working with relational databases (SQL Server, PostgreSQL, Oracle, MySQL, Ingres)	Required	7		Years
• Senior level experience writing optimized SQL queries and analyzing existing SQL queries for performance improvements	Required	7		Years
Solid understanding of SOAP/REST APIs, backend architecture, and microservices	Required	5		Years
Experience designing and executing data migration or data conversion projects	Required	7		Years
Understanding of data governance, security, and compliance requirements	Required	7		Years
Familiarity with legacy system migration projects	Highly desired	5		Years
Experience with large-scale migration or modernization initiatives	Highly desired	5		Years
Experience with Java development	Highly desired	5		Years
Experience with cloud platforms (AWS, Azure, GCP)	Desired	3		Years
Knowledge of Power BI administration, workspaces, gateways, and deployment strategies	Desired	3		Years
Experience with version control (Git/Subversion) and CI/CD pipelines	Desired	3		Years
Experience with Perl for scripting, system utilities, or legacy app maintenance	Nice to have	3		Years
Experience developing/maintaining applications Zope application server	Required
Experience developing/maintaining Plone CMS applications	Required

Questions	Questions	Answers
Question 1	Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2	All work must be completed on site. Exceptions to this policy will be made as/when possible to allow for teleworking during social distancing. Do you accept this requirement?
Question 3	Please list candidate's email address HERE that will be used when submitting E-RTR.
Question 4	Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.
Question 8	Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?