Software Engineer I - Data Developer

Position Information Working Title of Vacant Position Software Engineer I - Data Developer Job Type Full Time Posting Type Public Number of Vacancies 1 Department INFORMATION TECHNOLOGY Division IT SYSTEM DEV Requisition Number 2024370 Number of hours worked per week 40 Work Schedule 8AM – 5PM; Monday – Friday; Employees may be expected to work hours in excess of their normally scheduled hours in response to short-term department needs and/or City-wide emergencies. Work Site Location 300 Shea Dr Position Driving Requirement N - Never Pay Grade GE17 Pay Basis Semi-Monthly Advertised Salary $71,827 – $95,171; Depending on Qualifications and Experience. Job Description Position Overview: We are seeking a skilled Data Developer to join our team. The ideal candidate will focus on developing and maintaining SSIS and SSRS packages, integrating data between systems, assisting DBAs, and supporting our Master Data Management (MDM) project. A strong understanding of C# is a must. Key Responsibilities: Develop SSIS Packages: Design, develop, and maintain SQL Server Integration Services (SSIS) packages. Optimize ETL processes to ensure efficient data flow and processing. Troubleshoot and resolve issues with SSIS packages and data integrations. Create SSRS Reports: Design and develop SQL Server Reporting Services (SSRS) reports. Ensure reports are accurate, comprehensive, and meet business requirements. Perform ongoing maintenance and enhancements to existing reports. System Integration: Integrate data between various systems, ensuring seamless data flow. Develop and maintain data mapping and transformation rules. Collaborate with other teams to understand data requirements and ensure accurate data integration. Assist DBAs: Provide support to the Database Administrators in managing and optimizing databases. Assist in database performance tuning and query optimization. Support database maintenance tasks, including backups, indexing, and security. Software Development: Coding skills in languages such as C#, SQL, ASP.NET, and/or JavaScript. Assist in developing in-house web applications. Support Master Data Management (MDM): Participate in the Master Data Management project to ensure data consistency and accuracy. Assist in defining and implementing data governance policies and procedures. Work on data quality initiatives to cleanse and standardize master data. Please browse our Benefits Brochure, for a full list of benefits and employee perks. Required Qualifications VOCATIONAL/EDUCATIONAL REQUIREMENT: Requires a bachelor’s degree or any equivalent combination of education and experience in computer science or a closely related field. EXPERIENCE REQUIREMENT: In addition to satisfying the vocational/education standards, this class requires a minimum of two years of full-time experience in software development and engineering. SPECIAL REQUIREMENTS: Employees may be expected to work hours in excess of their normally scheduled hours in response to short-term department needs and/or City-wide emergencies. Preferred Qualifications A successful Software Engineer candidate will have various skills and qualifications that help them solve problems using large amounts of data. Coding skills in languages such as SQL, Python, C#, and/or JavaScript Analytical and problem-solving skills Experience with statistical software (e.g., Stata, SPSS) Knowledge of data gathering, cleaning and transforming techniques Reporting and data visualization skills using software like Power BI, Tableau, or others BI Tools Understanding of data warehousing and ETL techniques Proficiency in Microsoft Excel Ability to set and meet deadlines Experience with statistical software Technical writing skills Excellent attention to detail Strong written/verbal communication skills Ability to QA and troubleshoot data Posting Detail Information Job Open Date 09/18/2024 Job Close Date Open Continuous Yes Special Instructions to Applicants This position is eligible for sign-on bonus. Apply NOW! ADA Checklist Overall Physical Strength Demands Overall Physical Strength Demands S=Sedentary - Exerting up to 10 lbs. occasionally or small weights frequently; sitting most of the time. Physical Demands C = Continuously- 2/3 or more of the time. F = Frequently- From 1/3 to 2/3 of the time. O = Occasionally- Up to 1/3 of the time. R = Rarely- Less than 1 hour per week. N = Never- Never occurs. Standing Rarely- Less than 1 hour per week. Sitting Continuously- 2/3 or more of the time. Walking Rarely- Less than 1 hour per week. Lifting Rarely- Less than 1 hour per week. Lifting Amount Exerting up to 10 lbs Carrying Rarely- Less than 1 hour per week. Carrying Weight Exerting up to 10 lbs Pushing/Pulling Rarely- Less than 1 hour per week. Pushing/Pulling Weight Exerting up to 10 lbs Reaching Rarely- Less than 1 hour per week. Handling Rarely- Less than 1 hour per week. Fine Dexterity Rarely- Less than 1 hour per week. Kneeling Rarely- Less than 1 hour per week. Crouching Never- Never occurs. Crawling Rarely- Less than 1 hour per week. Bending Rarely- Less than 1 hour per week. Twisting Rarely- Less than 1 hour per week. Climbing Rarely- Less than 1 hour per week. Balancing Rarely- Less than 1 hour per week. Vision Continuously- 2/3 or more of the time. Hearing Frequently- From 1/3 to 2/3 of the time. Talking Frequently- From 1/3 to 2/3 of the time. Foot Controls Rarely- Less than 1 hour per week. Machines, Tools, Equipment and Work Aids Used Protective Equipment Required Health and Safety D = Daily W = Several Times Per Week M = Several Times Per Month S = Seasonally N = Never Mechanical Hazards N = Never Chemical Hazards N = Never Electrical Hazards N = Never Fire Hazards N = Never Explosives N = Never Communicable Diseases N = Never Physical Danger or Abuse N = Never Other N = Never If Other, Description Environmental Factors D = Daily W = Several Times Per Week M = Several Times Per Month S = Seasonally N = Never Dirt and Dust N = Never Extreme Temperatures N = Never Noise and Vibration N = Never Fumes and Odors N = Never Wetness/Humidity N = Never Darkness or Poor Lighting N = Never Primary Work Location Office Environment Non-Physical Demands C = Continuously- 2/3 or more of the time. F = Frequently- From 1/3 to 2/3 of the time. O = Occasionally- Up to 1/3 of the time. R = Rarely- Less than 1 hour per week. N = Never- Never occurs. Time Pressures Occasionally- Up to 1/3 of the time. Emergency Situations Rarely- Less than 1 hour per week. Frequent Change of Tasks Occasionally- Up to 1/3 of the time. Irregular Work Schedule/Overtime Rarely- Less than 1 hour per week. Performing Multiple Tasks Simultaneously Frequently- From 1/3 to 2/3 of the time. Working Closely with Others as Part of a Team Frequently- From 1/3 to 2/3 of the time. Tedious or Exacting Work Occasionally- Up to 1/3 of the time. Noisy/Distracting Environment Rarely- Less than 1 hour per week. Other Rarely- Less than 1 hour per week. If Other, Description Can anyone assist the employee in performing the primary tasks assigned to this position? If yes, identify the eligible task(s) No Professional References Professional References Please provide contact information for professional references. Minimum Requests 2 Maximum Requests 4