For the given job description <<General Summary
The Sr Business Systems Database Software Engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. This position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making.
Job Functions
Design, administer and maintain a robust and scalable data warehouse for our Solver-based Corporate Performance Management (CPM) system within the Microsoft Azure cloud environment.Utilize domain knowledge of production tracking tools such as ShotGrid and Ftrack to streamline data collection and analysis processes, feeding into the data warehouse.Manage Azure based SQL databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.Develop and optimize Python APIs to facilitate efficient and secure data access and retrieval from the data warehouse.Collaborate with Accounting and Finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.Build comprehensive and insightful financial and operational reports, leveraging the data warehouse.Create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.Take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.Provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes.
Qualifications
5+ years of professional experience in Computer Science, Information Technology, Finance or a related field as a Database Architect, Database Engineer or similar role.Proficiency in Microsoft Azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.Strong working knowledge of SQL databases, data modeling, and performance optimization techniques.Proven experience developing Python APIs for data retrieval and integration.Demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.Expertise in working with production tracking tools such as ShotGrid and Ftrack.Advanced skills in Microsoft Excel for building financial and operational reports.Excellent problem-solving skills and the ability to navigate complex business and financial requirements.Strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.Self-motivated, detail-oriented and adaptable to changing business needs.A passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies.
Physical Demands and Work Environment
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. The employee must lift andor move up to 15 pounds. Vision abilities include close vision, distance vision, and the ability to adjust focus.Work environment: While performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. The noise level is usually quiet or moderate.
Location
On-site in Hillsboro, OR  and also eligible for hybrid work  Remote Eligible.
Salary
Salary Is Commensurate With Skills And Experience.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
Please review our EMPLOYMENT DISCLAIMER and MATERIALS SUBMISSION AGREEMENT.>> the resume: <<Professional SummaryI am a design engineer with 8 years of experience in the electric utility industry. I am experienced in using design software, particularly AutoCAD, DistGIS (ArcMap), PLS, and DDS, to support transmission and distribution design projects. As a former distribution engineer with a large Southeastern U.S. electric utility, I provided line design and field survey services for 4 kV through 35 kV for the installation of new facilities and the upgrade of existing facilities. My specific competencies include customer communication and service, construction unit inventory, route layout, structure staking, distribution design calculations, property ownership research, easement and right-of-way (ROW) acquisition, and route surveys. I also provided field work and engineering support during storm response efforts.
ExperienceElectrical Engineer/Designer,09/2014to02/2016Leaf Engineers–Berkeley,CA,Designs complex overhead distribution projects in urban and rural environments in compliance with client's engineering and construction specifications, field engineering of project requirements, identification of conflicting utilities, engineering and design calculations, and work permit development.Complies with quality control and safe work practices and maintains compliance with project scopes, schedules and budgets.Proficiently learned 2 new design programs within a week that enabled me to double the teams design output which in turn led to more contract work for Leidos. Trains and assists new team members in designing distribution designs. Serves as a valuable resource for QA/QC of distribution designs that assures satisfaction of clients.Recently did asset inventory work for a northeast power company that involved creating databases to identify transmission structures, lines, and material.Worked many longs hours, some at my expense, to ensure deadlines were met.Currently working on a NERC project that identifies and resolves clearance conflicts with transmission lines.Distribution Engineer,12/2012to10/2014Leidos Holdings Inc.–Fort Knox,KY,Manage workload in eastern territory of Tuscaloosa District.Work daily with residential, commercial, and industrial customers to provide timely electrical service to new customers and/or service upgrades to existing facilities.Experience with providing distribution design work that includes overhead, URD, and underground cable/conduit design work in both urban and rural environments.Effectively communicated with customers by first listening intently to their needs before  providing a satisfying solution.Assured cost-per-install numbers stayed down by designing and estimating each customer's  job efficiently and accurately.Technician I,11/2007to12/2012Steris Corporation–Concord,NC,Provide timely, professional, and accurate drawings, using AutoCAD and DistGIS, to support engineers and other business needs.Monitor and address storm map packs and provide up to date single line sectionalizing wall maps for storm use as requested.Responsible for maintaining printing systems and supplies utilizing cost effective purchases.Assist with storm restoration efforts and field work.Reduced maximum turnaround time of drawings from 14 days to 3 days within a month of    employment to help meet committed service dates for customers.Learned how to effectively operate 3 large format plotters, a large format scanner, and a  large format laminator in two weeks.time with no prior knowledge or training of either  system.Trained others on how to use the large format systems more effectively which  minimized wasted printing supplies.Put into action a monthly maintenance cleaning schedule of plotter parts that resulted in  saving 8%  of annual operation and maintenance printing costs.Saved 12% of annual operation and maintenance printing costs by discovering a way to use  paper from a less expensive black and white plotter rather than a color plotter.Achieved 100% in call-out response for storm restoration.Contributed to the record breaking storm restoration efforts of the 2011 tornado outbreak by  working 12 hour shifts for 7 days printing and delivering maps to work sites.Supplied nearly  all of the maps that were needed for the Tuscaloosa area and surrounding areas.
EducationBachelor of Science:Electrical and Computer Engineering,Expected in2012toUniversity of Alabama-Tuscaloosa,ALGPA:Associate of Applied Science:Drafting Technology,Expected in2007toShelton State Community College-Tuscaloosa,ALGPA:
Technical SummaryAutoCAD, budgets, C, C++, designing, estimating, inventory, MathCad, MatLab, Microprocessors, Microsoft Office Suite, Networks, Programming, QA/QC, Transmission Power lines, Distribution Power lines, AutoCAD, DistGIS, SPICE, Distribution Design Studio, SAP, PLSCadd>>. The result is, No Fit

Fit assessment: No Fit